- 01. Lesson Introduction
- 02. Data Warehouse: A Closer Look
- 03. Choices for Implementing a Data Warehouse
- 04. DWH Dimensional Model Storage on AWS
- 05. Amazon Redshift Technology
- 06. Amazon Redshift Architecture
- 07. Redshift Architecture Example
- 08. SQL to SQL ETL
- 09. SQL to SQL ETL - AWS Case
- 10. Redshift & ETL in Context
- 11. Ingesting at Scale
- 12. Redshift ETL Examples
- 13. Redshift ETL Continued
- 14. Redshift Cluster Quick Launcher
- 15. Exercise 1: Launch Redshift Cluster
- 16. Problems with the Quick Launcher
- 17. Infrastructure as Code on AWS
- 18. Enabling Programmatic Access fo IaC
- 19. Demo: Infrastructure as Code
- 20. Exercise 2: Infrastructure as Code
- 21. Exercise Solution 2: Infrastructure as Code
- 22. Demo: Parallel ETL
- 23. Exercise 3: Parallel ETL
- 24. Exercise Solution 3: Parallel ETL
- 25. Optimizing Table Design
- 26. Distribution Style: Even
- 27. Distribution Style: All
- 28. Distribution Syle: Auto
- 29. Distribution Syle: Key
- 30. Sorting Key
- 31. Sorting Key Example
- 32. Demo: Table Design
- 33. Exercise 4: Table Design
- 34. Exercise Solution 4: Table Design
- 35. Conclusion